<?php

namespace app\admin\controller;
use think\Db;

class MemberBankinfo extends Common
{
    public function index()
    {
        $sou = request()->param();
        $bank_code = input("bank_code")?input("bank_code"):($sou["bank_code"]="");
        $query = Db::name("member_bankinfo")
            ->alias("mb")
            ->join("member m","mb.member_id=m.id")
            ->where("bank_code like '%$bank_code%'")
//            ->where("status=0")
            ->field(["mb.id","m.username","rale_name","bank_name","bank_code","child_name","mb.status"])
            ->paginate(10,false,['query'=>request()->param()]);
//        echo DB::table('member_bankinfo')->getlastsql();
        return view("index",["arr"=>$query,"sou"=>$sou]);
    }
    public function update(){
        
    }
    public function del(){

    }
}